using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VAPARTK
    {
        public void SetUpNewRow(ref DataRow dwReturn)
        {
            #region
            #endregion
            switch (app.company)
            {
                case "YGR":
                case "SXN":
                case "TST":
                case "UBT":
                default:
                    #region
                    dwReturn["APAKMANDANT"] = "00";
                    dwReturn["APAKWERK"] = "   ";
                    dwReturn["APAKANRKRS"] = "GY";
                    dwReturn["APAKALFDNR"] = "000004";
                    dwReturn["APAKAFOLGE"] = "020";
                    dwReturn["APAKAEVOR"] = "0001";
                    dwReturn["APAKAENDZL"] = "0";
                    dwReturn["APAKAENDBEN"] = "        ";
                    dwReturn["APAKAENDDAT"] = "0";
                    dwReturn["APAKNEUBEN"] = "LZH     ";
                    dwReturn["APAKNEUDAT"] = "20140528";
                    dwReturn["APAKSPSTA"] = "N";
                    dwReturn["APAKSPGRD"] = "                              ";
                    dwReturn["APAKMODKZ"] = " ";
                    dwReturn["APAKASCHLKZ"] = "N";
                    dwReturn["APAKKUNDNR"] = "        ";
                    dwReturn["APAKABT"] = "   ";
                    dwReturn["APAKART"] = "                    ";
                    dwReturn["APAKVAR"] = "   ";
                    dwReturn["APAKZUSATZ"] = "                     ";
                    dwReturn["APAKMEKOPFKZ"] = "2";
                    dwReturn["APAKAGANG"] = "               ";
                    dwReturn["APAKMTYP"] = "        ";
                    dwReturn["APAKPKSTKRS"] = "  ";
                    dwReturn["APAKPKST"] = "    ";
                    dwReturn["APAKMNRKRS"] = "  ";
                    dwReturn["APAKMLFDNR"] = "0000";
                    dwReturn["APAKMPOS"] = "00";
                    dwReturn["APAKBMNRKRS"] = "  ";
                    dwReturn["APAKBMLFDNR"] = "0611";
                    dwReturn["APAKBMPOS"] = "01";
                    dwReturn["APAKEVARHNR"] = "01";
                    dwReturn["APAKEVARUNR"] = "01";
                    dwReturn["APAKPRIO"] = "4";
                    dwReturn["APAKBASMGE"] = "50000";
                    dwReturn["APAKME"] = "1";
                    dwReturn["APAKFIX"] = "N";
                    dwReturn["APAKAGRVON"] = "0";
                    dwReturn["APAKAGRBIS"] = "0";
                    dwReturn["APAKAUFTRVON"] = "0";
                    dwReturn["APAKAUFTRBIS"] = "0";
                    dwReturn["APAKMASCHANZ"] = "1";
                    dwReturn["APAKMASCHZE"] = "MI";
                    dwReturn["APAKMASCHZT"] = "1";
                    dwReturn["APAKMINWMGE"] = "0";
                    dwReturn["APAKPERSANZ"] = "0";
                    dwReturn["APAKPERSZE"] = "  ";
                    dwReturn["APAKPERSZT"] = "0";
                    dwReturn["APAKPERSMB"] = "0";
                    dwReturn["APAKRUESTZE"] = "  ";
                    dwReturn["APAKRUESTZT"] = "0";
                    dwReturn["APAKRPERSZT"] = "0";
                    dwReturn["APAKRUESTFAM"] = "          ";
                    dwReturn["APAKVERWZE"] = "  ";
                    dwReturn["APAKVERWZTV"] = "0";
                    dwReturn["APAKVERWZTB"] = "0";
                    dwReturn["APAKVBKZ"] = " ";
                    dwReturn["APAKZEITBT1"] = "0";
                    dwReturn["APAKZEITBT2"] = "0";
                    dwReturn["APAKZEITBT3"] = "0";
                    dwReturn["APAKZEITBT4"] = "0";
                    dwReturn["APAKZEITBT5"] = "0";
                    dwReturn["APAKZEITBT6"] = "0";
                    dwReturn["APAKZEITBT7"] = "0";
                    dwReturn["APAKZEITBT8"] = "0";
                    dwReturn["APAKZEITBT9"] = "0";
                    dwReturn["APAKZEITBT10"] = "0";
                    dwReturn["APAKZEITBT11"] = "0";
                    dwReturn["APAKZEITBT12"] = "0";
                    dwReturn["APAKZEITBT13"] = "0";
                    dwReturn["APAKZEITBT14"] = "0";
                    dwReturn["APAKZEITBT15"] = "0";
                    dwReturn["APAKZEITBT16"] = "0";
                    dwReturn["APAKZEITBT17"] = "0";
                    dwReturn["APAKZEITBT18"] = "0";
                    dwReturn["APAKZEITBT19"] = "0";
                    dwReturn["APAKZEITBT20"] = "0";
                    dwReturn["APAKZEITBT21"] = "0";
                    dwReturn["APAKZEITBT22"] = "0";
                    dwReturn["APAKZEITBT23"] = "0";
                    dwReturn["APAKZEITBT24"] = "0";
                    dwReturn["APAKZEITBT25"] = "0";
                    dwReturn["APAKZEITBT26"] = "0";
                    dwReturn["APAKZEITBT27"] = "0";
                    dwReturn["APAKZEITBT28"] = "0";
                    dwReturn["APAKZEITBT29"] = "0";
                    dwReturn["APAKZEITBT30"] = "0";
                    dwReturn["APAKZEITBT31"] = "0";
                    dwReturn["APAKZEITBT32"] = "0";
                    dwReturn["APAKZEITBT33"] = "0";
                    dwReturn["APAKZEITBT34"] = "0";
                    dwReturn["APAKZEITBT35"] = "0";
                    dwReturn["APAKZEITBT36"] = "0";
                    dwReturn["APAKZEITBT37"] = "0";
                    dwReturn["APAKZEITBT38"] = "0";
                    dwReturn["APAKZEITBT39"] = "0";
                    dwReturn["APAKZEITBT40"] = "0";
                    dwReturn["APAKZEITBT41"] = "0";
                    dwReturn["APAKZEITBT42"] = "0";
                    dwReturn["APAKZEITBT43"] = "0";
                    dwReturn["APAKZEITBT44"] = "0";
                    dwReturn["APAKZEITBT45"] = "0";
                    dwReturn["APAKZEITBT46"] = "0";
                    dwReturn["APAKZEITBT47"] = "0";
                    dwReturn["APAKZEITBT48"] = "0";
                    dwReturn["APAKQUALI"] = "      ";
                    dwReturn["APAKLGRP"] = "      ";
                    dwReturn["APAKLZDR"] = " ";
                    dwReturn["APAKFILLER"] = "                                                                                   ";
                    #endregion
                    break;
            }
        }

        public void InsertAPARTK(DataRow dwData, string ITXDBVERSION = "50.24")
        {

            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                case "SXN":
                case "TST":
                case "UBT":
                default:
                    or1.CommandText = "INSERT INTO APARTK ( APAKMANDANT,APAKWERK,APAKANRKRS,APAKALFDNR,APAKAFOLGE,APAKAEVOR,APAKAENDZL,APAKAENDBEN,APAKAENDDAT,APAKNEUBEN,APAKNEUDAT,APAKSPSTA,APAKSPGRD,APAKMODKZ,APAKASCHLKZ,APAKKUNDNR,APAKABT,APAKART,APAKVAR,APAKZUSATZ,APAKMEKOPFKZ,APAKAGANG,APAKMTYP,APAKPKSTKRS,APAKPKST,APAKMNRKRS,APAKMLFDNR,APAKMPOS,APAKBMNRKRS,APAKBMLFDNR,APAKBMPOS,APAKEVARHNR,APAKEVARUNR,APAKPRIO,APAKBASMGE,APAKME,APAKFIX,APAKAGRVON,APAKAGRBIS,APAKAUFTRVON,APAKAUFTRBIS,APAKMASCHANZ,APAKMASCHZE,APAKMASCHZT,APAKMINWMGE,APAKPERSANZ,APAKPERSZE,APAKPERSZT,APAKPERSMB,APAKRUESTZE,APAKRUESTZT,APAKRPERSZT,APAKRUESTFAM,APAKVERWZE,APAKVERWZTV,APAKVERWZTB,APAKVBKZ,APAKZEITBT1,APAKZEITBT2,APAKZEITBT3,APAKZEITBT4,APAKZEITBT5,APAKZEITBT6,APAKZEITBT7,APAKZEITBT8,APAKZEITBT9,APAKZEITBT10,APAKZEITBT11,APAKZEITBT12,APAKZEITBT13,APAKZEITBT14,APAKZEITBT15,APAKZEITBT16,APAKZEITBT17,APAKZEITBT18,APAKZEITBT19,APAKZEITBT20,APAKZEITBT21,APAKZEITBT22,APAKZEITBT23,APAKZEITBT24,APAKZEITBT25,APAKZEITBT26,APAKZEITBT27,APAKZEITBT28,APAKZEITBT29,APAKZEITBT30,APAKZEITBT31,APAKZEITBT32,APAKZEITBT33,APAKZEITBT34,APAKZEITBT35,APAKZEITBT36,APAKZEITBT37,APAKZEITBT38,APAKZEITBT39,APAKZEITBT40,APAKZEITBT41,APAKZEITBT42,APAKZEITBT43,APAKZEITBT44,APAKZEITBT45,APAKZEITBT46,APAKZEITBT47,APAKZEITBT48,APAKQUALI,APAKLGRP,APAKLZDR,APAKFILLER)"
                   + " VALUES (:APAKMANDANT:,:APAKWERK:,:APAKANRKRS:,:APAKALFDNR:,:APAKAFOLGE:,:APAKAEVOR:,:APAKAENDZL:,:APAKAENDBEN:,:APAKAENDDAT:,:APAKNEUBEN:,:APAKNEUDAT:,:APAKSPSTA:,:APAKSPGRD:,:APAKMODKZ:,:APAKASCHLKZ:,:APAKKUNDNR:,:APAKABT:,:APAKART:,:APAKVAR:,:APAKZUSATZ:,:APAKMEKOPFKZ:,:APAKAGANG:,:APAKMTYP:,:APAKPKSTKRS:,:APAKPKST:,:APAKMNRKRS:,:APAKMLFDNR:,:APAKMPOS:,:APAKBMNRKRS:,:APAKBMLFDNR:,:APAKBMPOS:,:APAKEVARHNR:,:APAKEVARUNR:,:APAKPRIO:,:APAKBASMGE:,:APAKME:,:APAKFIX:,:APAKAGRVON:,:APAKAGRBIS:,:APAKAUFTRVON:,:APAKAUFTRBIS:,:APAKMASCHANZ:,:APAKMASCHZE:,:APAKMASCHZT:,:APAKMINWMGE:,:APAKPERSANZ:,:APAKPERSZE:,:APAKPERSZT:,:APAKPERSMB:,:APAKRUESTZE:,:APAKRUESTZT:,:APAKRPERSZT:,:APAKRUESTFAM:,:APAKVERWZE:,:APAKVERWZTV:,:APAKVERWZTB:,:APAKVBKZ:,:APAKZEITBT1:,:APAKZEITBT2:,:APAKZEITBT3:,:APAKZEITBT4:,:APAKZEITBT5:,:APAKZEITBT6:,:APAKZEITBT7:,:APAKZEITBT8:,:APAKZEITBT9:,:APAKZEITBT10:,:APAKZEITBT11:,:APAKZEITBT12:,:APAKZEITBT13:,:APAKZEITBT14:,:APAKZEITBT15:,:APAKZEITBT16:,:APAKZEITBT17:,:APAKZEITBT18:,:APAKZEITBT19:,:APAKZEITBT20:,:APAKZEITBT21:,:APAKZEITBT22:,:APAKZEITBT23:,:APAKZEITBT24:,:APAKZEITBT25:,:APAKZEITBT26:,:APAKZEITBT27:,:APAKZEITBT28:,:APAKZEITBT29:,:APAKZEITBT30:,:APAKZEITBT31:,:APAKZEITBT32:,:APAKZEITBT33:,:APAKZEITBT34:,:APAKZEITBT35:,:APAKZEITBT36:,:APAKZEITBT37:,:APAKZEITBT38:,:APAKZEITBT39:,:APAKZEITBT40:,:APAKZEITBT41:,:APAKZEITBT42:,:APAKZEITBT43:,:APAKZEITBT44:,:APAKZEITBT45:,:APAKZEITBT46:,:APAKZEITBT47:,:APAKZEITBT48:,:APAKQUALI:,:APAKLGRP:,:APAKLZDR:,:APAKFILLER:)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);

                    break;

            }
            Connect2Proxy(or1);
        }
        public DataSet QueryAPARTK(DataRow dwData, int option = 1)
        {

            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0: SResult = QAPL00(dwData); break;
                case 1: SResult = QAPL01(dwData); break;
                case 2: SResult = QAPL02(dwData); break;
                case 9999: SResult = QAPL00(dwData); break;
                default:
                    break;
            }

            return SResult;
        }
        public DataSet QAPL00(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM APARTK WHERE  ROWNUM<2 ";
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QAPL01(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT M.* FROM  APARTK M"
                                + " WHERE APAKMANDANT=:APAKMANDANT: AND APAKANRKRS=:APAKANRKRS: AND APAKALFDNR=:APAKALFDNR:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QAPL02(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT P.*,M.AMNRKRS,AMLFDNR,AMPOS FROM APARTK P JOIN AMSTAMM M ON   APAKPKSTKRS=AMKSTKRS AND APAKPKST=AMKST AND APAKMTYP=AMTYP AND AMSTDVAR='J'"
                              + " WHERE APAKMANDANT=:APAKMANDANT: AND APAKANRKRS=:APAKANRKRS: AND APAKALFDNR=:APAKALFDNR: AND APAKAFOLGE=:APAKAFOLGE:"
                              + dwData["APAKART"].ToString()
                              + dwData["APAKVAR"].ToString()
                              + dwData["APAKZUSATZ"].ToString();
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QAPL03(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT M.* FROM  APARTK M"
                                + " WHERE APAKMANDANT=:APAKMANDANT: AND APAKANRKRS=:APAKANRKRS: AND APAKALFDNR=:APAKALFDNR: AND APAKAFOLGE=:APAKAFOLGE: AND APAKAEVOR=:APAKAEVOR:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QAPL04(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT APAKAEVOR AS KEY, APAKAEVOR AS DES,M.* FROM  APARTK M"
                               + " WHERE APAKMANDANT=:APAKMANDANT: "
                               + dwData["APAKANRKRS"].ToString()
                               + dwData["APAKALFDNR"].ToString()
                               + dwData["APAKAFOLGE"].ToString()
                               + dwData["APAKAEVOR"].ToString();
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QAPL05(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT MAX(APAKAEVOR) AS APAKAEVOR FROM  APARTK"
              + " WHERE APAKMANDANT=:APAKMANDANT: AND APAKANRKRS=:APAKANRKRS: AND APAKALFDNR=:APAKALFDNR: AND APAKAFOLGE=:APAKAFOLGE: AND APAKART=:APAKART: AND APAKVAR=:APAKVAR: AND APAKZUSATZ=:APAKZUSATZ:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QAPL06(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT MAX(APAKAEVOR) AS APAKAEVOR FROM  APARTK"
              + " WHERE APAKMANDANT=:APAKMANDANT: AND APAKANRKRS=:APAKANRKRS: AND APAKALFDNR=:APAKALFDNR: AND APAKAFOLGE=:APAKAFOLGE:  ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public void DAPL00(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "DELETE FROM  APARTK"
                     + " WHERE APAKMANDANT=:APAKMANDANT: ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);

        }
        public void DAPL01(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "DELETE FROM  APARTK "
              + " WHERE APAKMANDANT=:APAKMANDANT: AND APAKANRKRS=:APAKANRKRS: AND APAKALFDNR=:APAKALFDNR: AND APAKAFOLGE=:APAKAFOLGE: AND APAKAEVOR=:APAKAEVOR:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);

        }
        public void DAPL02(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "DELETE FROM  APARTK"
            + " WHERE APAKMANDANT=:APAKMANDANT: AND APAKANRKRS=:APAKANRKRS: AND APAKALFDNR=:APAKALFDNR: AND APAKAFOLGE=:APAKAFOLGE: ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);

        }
        public void DAPL03(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "DELETE FROM  APARTK"
            + " WHERE APAKMANDANT=:APAKMANDANT: AND APAKANRKRS=:APAKANRKRS: AND APAKALFDNR=:APAKALFDNR:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }
        public void DAPL04(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "DELETE FROM  APARTK"
              + " WHERE APAKMANDANT=:APAKMANDANT: AND APAKANRKRS=:APAKANRKRS: AND APAKALFDNR=:APAKALFDNR: AND APAKAFOLGE=:APAKAFOLGE: AND APAKART=:APAKART: AND APAKVAR=:APAKVAR: AND APAKZUSATZ=:APAKZUSATZ:"; 
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }
        public void UpdateAPARTK(DataRow dwData, int option = 1)
        {
            if (option == 0)
            {
                switch (app.company)
                {
                    case "YGR":
                    case "SXN":
                    case "TST":
                    case "UBT":
                    default:
                        UAPL01(dwData);
                        break;
                }
            }
        }

        public void UAPL01(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "UPDATE APARTK SET APAKMANDANT=:APAKMANDANT:,APAKWERK=:APAKWERK:,APAKANRKRS=:APAKANRKRS:,APAKALFDNR=:APAKALFDNR:,APAKAFOLGE=:APAKAFOLGE:,APAKAEVOR=:APAKAEVOR:,APAKAENDZL=:APAKAENDZL:,APAKAENDBEN=:APAKAENDBEN:,APAKAENDDAT=:APAKAENDDAT:,APAKNEUBEN=:APAKNEUBEN:,APAKNEUDAT=:APAKNEUDAT:,APAKSPSTA=:APAKSPSTA:,APAKSPGRD=:APAKSPGRD:,APAKMODKZ=:APAKMODKZ:,APAKASCHLKZ=:APAKASCHLKZ:,APAKKUNDNR=:APAKKUNDNR:,APAKABT=:APAKABT:,APAKART=:APAKART:,APAKVAR=:APAKVAR:,APAKZUSATZ=:APAKZUSATZ:,APAKMEKOPFKZ=:APAKMEKOPFKZ:,APAKAGANG=:APAKAGANG:,APAKMTYP=:APAKMTYP:,APAKPKSTKRS=:APAKPKSTKRS:,APAKPKST=:APAKPKST:,APAKMNRKRS=:APAKMNRKRS:,APAKMLFDNR=:APAKMLFDNR:,APAKMPOS=:APAKMPOS:,APAKBMNRKRS=:APAKBMNRKRS:,APAKBMLFDNR=:APAKBMLFDNR:,APAKBMPOS=:APAKBMPOS:,APAKEVARHNR=:APAKEVARHNR:,APAKEVARUNR=:APAKEVARUNR:,APAKPRIO=:APAKPRIO:,APAKBASMGE=:APAKBASMGE:,APAKME=:APAKME:,APAKFIX=:APAKFIX:,APAKAGRVON=:APAKAGRVON:,APAKAGRBIS=:APAKAGRBIS:,APAKAUFTRVON=:APAKAUFTRVON:,APAKAUFTRBIS=:APAKAUFTRBIS:,APAKMASCHANZ=:APAKMASCHANZ:,APAKMASCHZE=:APAKMASCHZE:,APAKMASCHZT=:APAKMASCHZT:,APAKMINWMGE=:APAKMINWMGE:,APAKPERSANZ=:APAKPERSANZ:,APAKPERSZE=:APAKPERSZE:,APAKPERSZT=:APAKPERSZT:,APAKPERSMB=:APAKPERSMB:,APAKRUESTZE=:APAKRUESTZE:,APAKRUESTZT=:APAKRUESTZT:,APAKRPERSZT=:APAKRPERSZT:,APAKRUESTFAM=:APAKRUESTFAM:,APAKVERWZE=:APAKVERWZE:,APAKVERWZTV=:APAKVERWZTV:,APAKVERWZTB=:APAKVERWZTB:,APAKVBKZ=:APAKVBKZ:,APAKZEITBT1=:APAKZEITBT1:,APAKZEITBT2=:APAKZEITBT2:,APAKZEITBT3=:APAKZEITBT3:,APAKZEITBT4=:APAKZEITBT4:,APAKZEITBT5=:APAKZEITBT5:,APAKZEITBT6=:APAKZEITBT6:,APAKZEITBT7=:APAKZEITBT7:,APAKZEITBT8=:APAKZEITBT8:,APAKZEITBT9=:APAKZEITBT9:,APAKZEITBT10=:APAKZEITBT10:,APAKZEITBT11=:APAKZEITBT11:,APAKZEITBT12=:APAKZEITBT12:,APAKZEITBT13=:APAKZEITBT13:,APAKZEITBT14=:APAKZEITBT14:,APAKZEITBT15=:APAKZEITBT15:,APAKZEITBT16=:APAKZEITBT16:,APAKZEITBT17=:APAKZEITBT17:,APAKZEITBT18=:APAKZEITBT18:,APAKZEITBT19=:APAKZEITBT19:,APAKZEITBT20=:APAKZEITBT20:,APAKZEITBT21=:APAKZEITBT21:,APAKZEITBT22=:APAKZEITBT22:,APAKZEITBT23=:APAKZEITBT23:,APAKZEITBT24=:APAKZEITBT24:,APAKZEITBT25=:APAKZEITBT25:,APAKZEITBT26=:APAKZEITBT26:,APAKZEITBT27=:APAKZEITBT27:,APAKZEITBT28=:APAKZEITBT28:,APAKZEITBT29=:APAKZEITBT29:,APAKZEITBT30=:APAKZEITBT30:,APAKZEITBT31=:APAKZEITBT31:,APAKZEITBT32=:APAKZEITBT32:,APAKZEITBT33=:APAKZEITBT33:,APAKZEITBT34=:APAKZEITBT34:,APAKZEITBT35=:APAKZEITBT35:,APAKZEITBT36=:APAKZEITBT36:,APAKZEITBT37=:APAKZEITBT37:,APAKZEITBT38=:APAKZEITBT38:,APAKZEITBT39=:APAKZEITBT39:,APAKZEITBT40=:APAKZEITBT40:,APAKZEITBT41=:APAKZEITBT41:,APAKZEITBT42=:APAKZEITBT42:,APAKZEITBT43=:APAKZEITBT43:,APAKZEITBT44=:APAKZEITBT44:,APAKZEITBT45=:APAKZEITBT45:,APAKZEITBT46=:APAKZEITBT46:,APAKZEITBT47=:APAKZEITBT47:,APAKZEITBT48=:APAKZEITBT48:,APAKQUALI=:APAKQUALI:,APAKLGRP=:APAKLGRP:,APAKLZDR=:APAKLZDR:,APAKFILLER=:APAKFILLER:"
             + " WHERE APAKMANDANT=:APAKMANDANT: AND APAKANRKRS=:APAKANRKRS: AND APAKALFDNR=:APAKALFDNR: AND APAKAFOLGE=:APAKAFOLGE: AND APAKAEVOR=:APAKAEVOR:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);

        }
    }

}
